package com.kvest.sqlitetest.datastorage.sqlitestorage.table;

import android.provider.BaseColumns;

/**
 * Created with IntelliJ IDEA.
 * User: Kvest
 * Date: 09.06.13
 * Time: 12:02
 * To change this template use File | Settings | File Templates.
 */
public abstract class PersonTable implements BaseColumns{
    public static final String TABLE_NAME = "person";

    public static final String FIRST_NAME_COLUMN = "first_name";
    public static final String LAST_NAME_COLUMN = "last_name";
    public static final String DAY_OF_BIRTH_COLUMN = "day_of_birth";
    public static final String MONTH_OF_BIRTH_COLUMN = "month_of_birth";
    public static final String YEAR_OF_BIRTH_COLUMN = "year_of_birth";
    public static final String COUNTRY_COLUMN = "country";

    public static final String CREATE_TABLE_SQL = "CREATE TABLE \'" + TABLE_NAME + "'(\'" +
                                                    _ID + "\' INTEGER PRIMARY KEY AUTOINCREMENT, \'" +
                                                    FIRST_NAME_COLUMN + "\' TEXT, \'" +
                                                    LAST_NAME_COLUMN + "\' TEXT, \'" +
                                                    DAY_OF_BIRTH_COLUMN + "\' INTEGER, \'" +
                                                    MONTH_OF_BIRTH_COLUMN + "\' INTEGER, \'" +
                                                    YEAR_OF_BIRTH_COLUMN + "\' INTEGER, \'" +
                                                    COUNTRY_COLUMN + "\' TEXT DEFAULT \'UA\');";
    public static final String DROP_TABLE_SQL = "DROP TABLE IF EXISTS \'" + TABLE_NAME + "\';";
}
